[dbo].[BAEImisNameGetAllByCompanyId]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEImisNameGetAllByCompanyId
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@companyId
varchar(5)
5
SQL Script
create
procedure
[dbo]
.
[BAEImisNameGetAllByCompanyId]
@companyId
varchar
(
5
)
as
SELECT
ID
FROM
Name
WHERE
CO_ID
=
@companyId
GO
Uses
[dbo].[Name]
dbo